{
  "statement":"select c_city, s_city, d_year, sum(lo_revenue) as lo_revenue from lineorder_l join dates on lo_orderdate \u003d d_datekey join customer on lo_custkey \u003d c_custkey join supplier on lo_suppkey \u003d s_suppkey where (c_city\u003d\u0027UNITED KI1\u0027 or c_city\u003d\u0027UNITED KI5\u0027) and (s_city\u003d\u0027UNITED KI1\u0027 or s_city\u003d\u0027UNITED KI5\u0027) and d_yearmonth \u003d \u0027Dec1997\u0027 group by c_city, s_city, d_year order by d_year asc, lo_revenue desc;\n",
  "table_meta":{
    "ssb.dates":"CREATE TABLE `dates` (\n  `d_datekey` int(11) NOT NULL COMMENT \"\",\n  `d_date` varchar(20) NOT NULL COMMENT \"\",\n  `d_dayofweek` varchar(10) NOT NULL COMMENT \"\",\n  `d_month` varchar(11) NOT NULL COMMENT \"\",\n  `d_year` int(11) NOT NULL COMMENT \"\",\n  `d_yearmonthnum` int(11) NOT NULL COMMENT \"\",\n  `d_yearmonth` varchar(9) NOT NULL COMMENT \"\",\n  `d_daynuminweek` int(11) NOT NULL COMMENT \"\",\n  `d_daynuminmonth` int(11) NOT NULL COMMENT \"\",\n  `d_daynuminyear` int(11) NOT NULL COMMENT \"\",\n  `d_monthnuminyear` int(11) NOT NULL COMMENT \"\",\n  `d_weeknuminyear` int(11) NOT NULL COMMENT \"\",\n  `d_sellingseason` varchar(14) NOT NULL COMMENT \"\",\n  `d_lastdayinweekfl` int(11) NOT NULL COMMENT \"\",\n  `d_lastdayinmonthfl` int(11) NOT NULL COMMENT \"\",\n  `d_holidayfl` int(11) NOT NULL COMMENT \"\",\n  `d_weekdayfl` int(11) NOT NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`d_datekey`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`d_datekey`) BUCKETS 1 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\"\n);",
    "ssb.customer":"CREATE TABLE `customer` (\n  `c_custkey` int(11) NOT NULL COMMENT \"\",\n  `c_name` varchar(26) NOT NULL COMMENT \"\",\n  `c_address` varchar(41) NOT NULL COMMENT \"\",\n  `c_city` varchar(11) NOT NULL COMMENT \"\",\n  `c_nation` varchar(16) NOT NULL COMMENT \"\",\n  `c_region` varchar(13) NOT NULL COMMENT \"\",\n  `c_phone` varchar(16) NOT NULL COMMENT \"\",\n  `c_mktsegment` varchar(11) NOT NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`c_custkey`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`c_custkey`) BUCKETS 1 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\"\n);",
    "ssb.lineorder_l":"CREATE TABLE `lineorder_l` (\n  `lo_orderkey` int(11) NOT NULL COMMENT \"\",\n  `lo_linenumber` int(11) NOT NULL COMMENT \"\",\n  `lo_custkey` int(11) NOT NULL COMMENT \"\",\n  `lo_partkey` int(11) NOT NULL COMMENT \"\",\n  `lo_suppkey` int(11) NOT NULL COMMENT \"\",\n  `lo_orderdate` int(11) NOT NULL COMMENT \"\",\n  `lo_orderpriotity` varchar(16) NOT NULL COMMENT \"\",\n  `lo_shippriotity` int(11) NOT NULL COMMENT \"\",\n  `lo_quantity` int(11) NOT NULL COMMENT \"\",\n  `lo_extendedprice` int(11) NOT NULL COMMENT \"\",\n  `lo_ordtotalprice` int(11) NOT NULL COMMENT \"\",\n  `lo_discount` int(11) NOT NULL COMMENT \"\",\n  `lo_revenue` int(11) NOT NULL COMMENT \"\",\n  `lo_supplycost` int(11) NOT NULL COMMENT \"\",\n  `lo_tax` int(11) NOT NULL COMMENT \"\",\n  `lo_commitdate` int(11) NOT NULL COMMENT \"\",\n  `lo_shipmode` varchar(11) NOT NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`lo_orderkey`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`lo_orderkey`) BUCKETS 192 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"colocate_with\" \u003d \"x23123fel\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\"\n);",
    "ssb.supplier":"CREATE TABLE `supplier` (\n  `s_suppkey` int(11) NOT NULL COMMENT \"\",\n  `s_name` varchar(26) NOT NULL COMMENT \"\",\n  `s_address` varchar(26) NOT NULL COMMENT \"\",\n  `s_city` varchar(11) NOT NULL COMMENT \"\",\n  `s_nation` varchar(16) NOT NULL COMMENT \"\",\n  `s_region` varchar(13) NOT NULL COMMENT \"\",\n  `s_phone` varchar(16) NOT NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`s_suppkey`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`s_suppkey`) BUCKETS 1 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\"\n);"
  },
  "table_row_count":{
    "ssb.supplier":{
      "supplier":200000
    },
    "ssb.lineorder_l":{
      "lineorder_l":600037902
    },
    "ssb.dates":{
      "dates":2556
    },
    "ssb.customer":{
      "customer":3000000
    }
  },
  "session_variables":"{\"runtime_join_filter_push_down_limit\":1024000,\"codegen_level\":0,\"character_set_connection\":\"utf8\",\"enable_insert_strict\":false,\"div_precision_increment\":4,\"tx_isolation\":\"REPEATABLE-READ\",\"wait_timeout\":28800,\"auto_increment_increment\":1,\"foreign_key_checks\":true,\"character_set_client\":\"utf8\",\"autocommit\":true,\"character_set_results\":\"utf8\",\"parallel_fragment_exec_instance_num\":1,\"max_scan_key_num\":-1,\"enable_global_runtime_filter\":true,\"forward_to_master\":false,\"net_read_timeout\":60,\"streaming_preaggregation_mode\":\"auto\",\"storage_engine\":\"olap\",\"tx_visible_wait_timeout\":10,\"new_planner_optimize_timeout\":3000000,\"force_schedule_local\":false,\"enable_query_dump\":false,\"prefer_join_method\":\"broadcast\",\"load_mem_limit\":0,\"sql_select_limit\":9223372036854775807,\"profiling\":false,\"sql_safe_updates\":0,\"enable_new_planner_mock_tpch_statistic\":false,\"query_cache_type\":0,\"use_v2_rollup\":false,\"disable_colocate_join\":false,\"max_pushdown_conditions_per_column\":-1,\"global_runtime_filter_max_size\":4096000,\"new_planner_tpch_scale\":1,\"enable_vectorized_engine\":true,\"net_write_timeout\":60,\"collation_database\":\"utf8_general_ci\",\"hash_join_push_down_right_table\":true,\"new_planner_agg_stage\":0,\"collation_connection\":\"utf8_general_ci\",\"resource_group\":\"normal\",\"enable_new_planner_push_down_join_to_agg\":false,\"broadcast_row_limit\":15000000,\"exec_mem_limit\":21474836480,\"disable_join_reorder\":false,\"enable_profile\":true,\"global_runtime_filter_rpc_timeout\":400,\"enable_groupby_use_output_alias\":false,\"global_runtime_filter_wait_timeout\":200,\"enable_vectorized_insert\":true,\"net_buffer_length\":16384,\"transmission_compression_type\":\"LZ4\",\"interactive_timeout\":3600,\"enable_spilling\":false,\"batch_size\":1024,\"max_allowed_packet\":1048576,\"query_timeout\":180,\"test_materialized_view\":false,\"enable_cbo\":true,\"collation_server\":\"utf8_general_ci\",\"new_planner_max_transform_reorder_joins\":3,\"time_zone\":\"CST\",\"max_execution_time\":3000000,\"character_set_server\":\"utf8\",\"rewrite_count_distinct_to_bitmap_hll\":true,\"parallel_exchange_instance_num\":-1,\"sql_mode\":34,\"SQL_AUTO_IS_NULL\":false,\"event_scheduler\":\"OFF\",\"disable_streaming_preaggregations\":false}",
  "column_statistics":{
    "ssb.supplier":{
      "s_city":"[-Infinity, Infinity, 0.0, 10.0, 250.0]",
      "s_suppkey":"[1.0, 200000.0, 0.0, 4.0, 200000.0]"
    },
    "ssb.lineorder_l":{
      "lo_custkey":"[128.0, 2999999.0, 0.0, 4.0, 50939.0]",
      "lo_revenue":"[84348.0, 1.035985E7, 0.0, 4.0, 4138926.0]",
      "lo_suppkey":"[1.0, 200000.0, 0.0, 4.0, 200496.0]",
      "lo_orderdate":"[1.9920101E7, 1.9980802E7, 0.0, 4.0, 2406.0]"
    },
    "ssb.dates":{
      "d_datekey":"[1.9920101E7, 1.998123E7, 0.0, 4.0, 2556.0]",
      "d_yearmonth":"[-Infinity, Infinity, 0.0, 7.0, 84.0]",
      "d_year":"[1992.0, 1998.0, 0.0, 4.0, 7.0]"
    },
    "ssb.customer":{
      "c_custkey":"[1.0, 200000.0, 0.0, 4.0, 3000000.0]",
      "c_city":"[-Infinity, Infinity, 0.0, 10.0, 250.0]"
    }
  },
  "be_number":3,
  "exception":[

  ]
}